UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IkcHnOE4O19N1F7whDuMmeC/Sk/4UW8CuSyYZtUGYI='
WHERE
key_id = 'fc99a101c5889b8a91fc01129dc6cb8b160a1a4fae9ca4117aeff366963519a0'
AND (
token = '/IkcHnOE4O19N1F7whDuMmeC/Sk/4UW8CuSyYZtUGYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)