UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GM77BC1606F75KxUSIUFwpDcVb/847B0uit4YhUHZ24='
WHERE
key_id = 'c1ed64736971bd51c81c6509ae7532def73e2cd72978c520e5d1c9f81f3adc01'
AND (
token = 'GM77BC1606F75KxUSIUFwpDcVb/847B0uit4YhUHZ24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)