UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tFgqdVJUdAYYUF18bHbuICGicEHNVLZLp0no6QAUkC4='
WHERE
key_id = 'b1df010671fb03efa3b5120aab2ddaa0f984d58b320ba6ea17f08b88a5fb6905'
AND (
token = 'tFgqdVJUdAYYUF18bHbuICGicEHNVLZLp0no6QAUkC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)