UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'edC6zB69r96hAMOxCInaHvZrnlbylxgFYXu3nFe616k='
WHERE
key_id = 'a6bcbbc4236ce64ab8577e5aecbcf91de3c4a42e592e96b73b4d6786d77b21e3'
AND (
token = 'edC6zB69r96hAMOxCInaHvZrnlbylxgFYXu3nFe616k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)