UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16hsmXWEt0OK5foZ23HBF+CLW3MSP8k9lRQLZK7v8YQ='
WHERE
key_id = '6605f08664c487211083aa36d052375bc69c3c7dfba230c8f192d4078398f7b2'
AND (
token = '16hsmXWEt0OK5foZ23HBF+CLW3MSP8k9lRQLZK7v8YQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)