UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IFq7Y+vKMuw/JGgvLL02ohxClBKqFL9FfML8+Vhv5zU='
WHERE
key_id = '165d644abb7812679ce1e860c8ad02336ab569769981d8513bf223ca11eaa026'
AND (
token = 'IFq7Y+vKMuw/JGgvLL02ohxClBKqFL9FfML8+Vhv5zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)