UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6xyOVhPjpIGkHVv9OgNeP9Np6V7+hPacL8U/dYJk8Y='
WHERE
key_id = 'cf0a1ff60fd6b199249431d2de10f9d64b81f683b75c47efa33ad9d69c52b7ed'
AND (
token = 'w6xyOVhPjpIGkHVv9OgNeP9Np6V7+hPacL8U/dYJk8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)