UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8vxCjPG9K6HwFow5ycr4BrkCeKt+FPS0HUw6lk5+NI='
WHERE
key_id = '3fa6305ca13e9600172e3ee8306e5301aec882f38b221e8783f8150992675e39'
AND (
token = 'G8vxCjPG9K6HwFow5ycr4BrkCeKt+FPS0HUw6lk5+NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)