UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'frI8RJ9+hPRMRjJmb9KMz/NvYcSf4KhOK4Gbh2o/ADw='
WHERE
key_id = 'ad1f069149176cb14b6a1a411fa741a1492921b9601132fd1bac662be44b018a'
AND (
token = 'frI8RJ9+hPRMRjJmb9KMz/NvYcSf4KhOK4Gbh2o/ADw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)