UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+GTM0w1cx7KIkdziDaUFYAiE3OLSHvKCc3Vj3B57Y0='
WHERE
key_id = '0392e67d39bd33471debb480b2eb52f8e82804b0f751447dc156c50383eceb10'
AND (
token = 'z+GTM0w1cx7KIkdziDaUFYAiE3OLSHvKCc3Vj3B57Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)