UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4vkzrJka7y638wKUwD/9MwIqVj7wLm9VGhCNakDgcuk='
WHERE
key_id = '9ab1303be3a4a27b54699ae9701221a573dbbd93dc2bb694eb1dc42b6020f4cf'
AND (
token = '4vkzrJka7y638wKUwD/9MwIqVj7wLm9VGhCNakDgcuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)