UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/trbJXBvUUa7MWN+/rtv02kM0f925Qw4B/sKjjuNv3U='
WHERE
key_id = 'b23863bc358940435606689030c7c3642f6d6d936adfae937a6eb2d425a2e9b4'
AND (
token = '/trbJXBvUUa7MWN+/rtv02kM0f925Qw4B/sKjjuNv3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)