UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zl9P9jjNyHVYoFyfEdDrh/G2d95EVcIVEC6pl4OOOks='
WHERE
key_id = 'bdedcfed60eee0e7725629ca85600eacd3b46617f3901da6e95e7b67fcd75a86'
AND (
token = 'zl9P9jjNyHVYoFyfEdDrh/G2d95EVcIVEC6pl4OOOks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)