UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9B3Tld30QUnhu602LHO2mE9Z3DxGKijtBLgy9UmSNsM='
WHERE
key_id = '417eb0a12149ee9d9344b612eb7f1010259b616d35aa59bda0572e7108a08ecc'
AND (
token = '9B3Tld30QUnhu602LHO2mE9Z3DxGKijtBLgy9UmSNsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)