UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VL2LXtzb1dqV7EkNru+4TQE/8/x7jXOtJWXHGrd9KBg='
WHERE
key_id = 'fe2f9de94bcb226b5c0a9628d114e833a90622885489b089b108991c192b2fc7'
AND (
token = 'VL2LXtzb1dqV7EkNru+4TQE/8/x7jXOtJWXHGrd9KBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)