UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCTXngzhnHhCRwMUzTOTQW6GRMdFEFIXS8ubsa50xQY='
WHERE
key_id = '5c6c4e40667f063d4bdb221c018eba10e56b69075d507b83c4fb39a51ac4d91f'
AND (
token = 'zCTXngzhnHhCRwMUzTOTQW6GRMdFEFIXS8ubsa50xQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)