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