UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhIhv4Pr8N9S+7GWL8oEd3w1iANqprfY5uEVfQucU4o='
WHERE
key_id = '47c9c133e76c073452739728ef5280e3265cd56a3183018bbe0ed9d8ca1f7bb7'
AND (
token = 'ZhIhv4Pr8N9S+7GWL8oEd3w1iANqprfY5uEVfQucU4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)