UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2VkHaY0G9LCe6URlF+zbaDMw427hjU02zrb2h+ohVQI='
WHERE
key_id = 'dbbb4108114f0c721dafa9b5726d4f25a6f34c5de0a6d64c81ee792f8bf6d9b2'
AND (
token = '2VkHaY0G9LCe6URlF+zbaDMw427hjU02zrb2h+ohVQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)