UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7U9O5PjzX4kBKsHdNpBlCIkY+yGIcdROd4pmdt5PGA='
WHERE
key_id = 'a8a7cdd1828b2026f2c55bb0604656bde3ee2e6f86a21440735783138cf9e43c'
AND (
token = 'N7U9O5PjzX4kBKsHdNpBlCIkY+yGIcdROd4pmdt5PGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)