UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'De7/25/98AfKjwjp97vfV3Hxlazt/Q726yYKzWUuGlo='
WHERE
key_id = '578185dbda71363f63cce98c4bca579f5a5fd59e816e13b6a504764a693ad9a9'
AND (
token = 'De7/25/98AfKjwjp97vfV3Hxlazt/Q726yYKzWUuGlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)