UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bYLukxj3GE0XJqRVXzViVSuE8PL9ubqm9Dor0WsbCI='
WHERE
key_id = 'cfb1d0e75b45e4bc6f721981b6a807847c47eb2e02b464a49b0866d7b6753f34'
AND (
token = '3bYLukxj3GE0XJqRVXzViVSuE8PL9ubqm9Dor0WsbCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)