UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aovKaG1JwLs5X8y6xqkrIcihzKF2Cw36TCWkoN5hfno='
WHERE
key_id = '1a7e89a51cf702c53c39afbb41267054f28f16f8ad895f7f25a9171aaf65d258'
AND (
token = 'aovKaG1JwLs5X8y6xqkrIcihzKF2Cw36TCWkoN5hfno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)