UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opydCLZ8RMRhoE/17PfSpNL35UHm2xKp3nqlw51CZsM='
WHERE
key_id = 'c0d07750fa7b3af02c45af5dab8e3192dfe9234cf7d60068c435aebde35ee893'
AND (
token = 'opydCLZ8RMRhoE/17PfSpNL35UHm2xKp3nqlw51CZsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)