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