UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhKjjCwTg1jDppEt2FIUnDE3+6BdEQakAzPx9+k4OAY='
WHERE
key_id = 'c7bd1fbe432b9ef14fbe8c647adc94e714396c56a3cad74a5ff136f081ef6eda'
AND (
token = 'VhKjjCwTg1jDppEt2FIUnDE3+6BdEQakAzPx9+k4OAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)