UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uA7+knU1sRb1AwHpIQjEcC2RJPU4P22wkyUfhMy9jbg='
WHERE
key_id = '6fb5b5e5873ea316f83748ce9c89972e25ab6990e5ffb4138176fbaa145151be'
AND (
token = 'uA7+knU1sRb1AwHpIQjEcC2RJPU4P22wkyUfhMy9jbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)