UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q3A/SO8WZLzRCwpXQHmx80ZTkc7zGBS8iQjQXOi1+s8='
WHERE
key_id = '04247f28be0c4a534b79455c7c37bdebcf8616a7d07576f15dc6c28c36c65379'
AND (
token = 'Q3A/SO8WZLzRCwpXQHmx80ZTkc7zGBS8iQjQXOi1+s8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)