UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YtO/6Oju+6mLyoHnNMrQ9OF1Izu2mGmMjWNZE/QB6fg='
WHERE
key_id = 'f8846cc807b9fefdc0d0a7589b0cad3bfe10c49c5161ee0f7a3a4099a0ce8181'
AND (
token = 'YtO/6Oju+6mLyoHnNMrQ9OF1Izu2mGmMjWNZE/QB6fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)